model dataset profile

Dataset statistics

Number of variables	20
Number of observations	9725
Missing cells	9676
Missing cells (%)	5.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	153.0 B

Variable types

Numeric	14
Categorical	5
Boolean	1

Warnings

`over_under_line` has a high cardinality: 68 distinct values	High cardinality
`elo1_pre` is highly correlated with `qbelo1_pre`	High correlation
`elo2_pre` is highly correlated with `qbelo2_pre`	High correlation
`elo_prob1` is highly correlated with `elo_prob2` and 2 other fields	High correlation
`elo_prob2` is highly correlated with `elo_prob1` and 2 other fields	High correlation
`qbelo1_pre` is highly correlated with `elo1_pre`	High correlation
`qbelo2_pre` is highly correlated with `elo2_pre`	High correlation
`qbelo_prob1` is highly correlated with `elo_prob1` and 2 other fields	High correlation
`qbelo_prob2` is highly correlated with `elo_prob1` and 2 other fields	High correlation
`stadium_neutral` is highly correlated with `compass_home`	High correlation
`compass_home` is highly correlated with `stadium_neutral`	High correlation
`compass_home` has 9676 (99.5%) missing values	Missing
`dt_for_home` is highly skewed (γ1 = 21.07824614)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`qbelo1_pre` has unique values	Unique
`qbelo2_pre` has unique values	Unique
`qbelo_prob1` has unique values	Unique
`qbelo_prob2` has unique values	Unique
`spread_favorite` has 133 (1.4%) zeros	Zeros
`dt_for_home` has 9676 (99.5%) zeros	Zeros

Reproduction

Analysis started	2021-04-16 16:49:53.648888
Analysis finished	2021-04-16 16:50:15.882873
Duration	22.23 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	9725
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7160
Minimum	2298
Maximum	12022
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	2298
5-th percentile	2784.2
Q1	4729
median	7160
Q3	9591
95-th percentile	11535.8
Maximum	12022
Range	9724
Interquartile range (IQR)	4862

Descriptive statistics

Standard deviation	2807.510018
Coefficient of variation (CV)	0.3921103377
Kurtosis	-1.2
Mean	7160
Median Absolute Deviation (MAD)	2431
Skewness	0
Sum	69631000
Variance	7882112.5
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4098	1	< 0.1%
2740	1	< 0.1%
4791	1	< 0.1%
10936	1	< 0.1%
8889	1	< 0.1%
2748	1	< 0.1%
6846	1	< 0.1%
4799	1	< 0.1%
10944	1	< 0.1%
8897	1	< 0.1%
Other values (9715)	9715	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2298	1	< 0.1%
2299	1	< 0.1%
2300	1	< 0.1%
2301	1	< 0.1%
2302	1	< 0.1%

Value	Count	Frequency (%)
12022	1	< 0.1%
12021	1	< 0.1%
12020	1	< 0.1%
12019	1	< 0.1%
12018	1	< 0.1%

result
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	76.1 KiB

1	5637
0	4088

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9725
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	5637	58.0%
0	4088	42.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	5637	58.0%
0	4088	42.0%

Most occurring characters

Value	Count	Frequency (%)
1	5637	58.0%
0	4088	42.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9725	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	5637	58.0%
0	4088	42.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9725	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	5637	58.0%
0	4088	42.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9725	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	5637	58.0%
0	4088	42.0%

spread_favorite
Real number (ℝ)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-5.394190231
Minimum	-26.5
Maximum	0
Zeros	133
Zeros (%)	1.4%
Memory size	76.1 KiB

Quantile statistics

Minimum	-26.5
5-th percentile	-12.5
Q1	-7
median	-4.5
Q3	-3
95-th percentile	-1
Maximum	0
Range	26.5
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.430153417
Coefficient of variation (CV)	-0.6358977473
Kurtosis	1.163035489
Mean	-5.394190231
Median Absolute Deviation (MAD)	2
Skewness	-1.066664965
Sum	-52458.5
Variance	11.76595246
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
-3	1492	15.3%
-3.5	763	7.8%
-7	701	7.2%
-2.5	626	6.4%
-6	532	5.5%
-4	530	5.4%
-6.5	489	5.0%
-1	472	4.9%
-2	421	4.3%
-4.5	342	3.5%
Other values (37)	3357	34.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-26.5	1	< 0.1%
-24.5	1	< 0.1%
-24	1	< 0.1%
-22.5	1	< 0.1%
-21.5	1	< 0.1%

Value	Count	Frequency (%)
0	133	1.4%
-1	472	4.9%
-1.5	302	3.1%
-2	421	4.3%
-2.5	626	6.4%

over_under_line
Categorical

HIGH CARDINALITY

Distinct	68
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	76.1 KiB

41	564
44	511
42	507
43	487
37	474
Other values (63)	7182

Length

Max length	4
Median length	2
Mean length	2.692133676
Min length	1

Characters and Unicode

Total characters	26181
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	0.1%

Sample

1st row	30
2nd row	39
3rd row	31
4th row	31.5
5th row	37

Value	Count	Frequency (%)
41	564	5.8%
44	511	5.3%
42	507	5.2%
43	487	5.0%
37	474	4.9%
40	470	4.8%
38	451	4.6%
39	425	4.4%
45	410	4.2%
43.5	309	3.2%
Other values (58)	5117	52.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
41	564	5.8%
44	511	5.3%
42	507	5.2%
43	487	5.0%
37	474	4.9%
40	470	4.9%
38	451	4.7%
39	425	4.4%
45	410	4.2%
43.5	309	3.2%
Other values (57)	5062	52.3%

Most occurring characters

Value	Count	Frequency (%)
4	6952	26.6%
5	4941	18.9%
3	4136	15.8%
.	3393	13.0%
7	1156	4.4%
8	993	3.8%
1	989	3.8%
6	975	3.7%
2	889	3.4%
0	860	3.3%
Other values (2)	897	3.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	22733	86.8%
Other Punctuation	3393	13.0%
Space Separator	55	0.2%

Most frequent character per category

Value	Count	Frequency (%)
4	6952	30.6%
5	4941	21.7%
3	4136	18.2%
7	1156	5.1%
8	993	4.4%
1	989	4.4%
6	975	4.3%
2	889	3.9%
0	860	3.8%
9	842	3.7%

Value	Count	Frequency (%)
.	3393	100.0%

Value	Count	Frequency (%)
	55	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	26181	100.0%

Most frequent character per script

Value	Count	Frequency (%)
4	6952	26.6%
5	4941	18.9%
3	4136	15.8%
.	3393	13.0%
7	1156	4.4%
8	993	3.8%
1	989	3.8%
6	975	3.7%
2	889	3.4%
0	860	3.3%
Other values (2)	897	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26181	100.0%

Most frequent character per block

Value	Count	Frequency (%)
4	6952	26.6%
5	4941	18.9%
3	4136	15.8%
.	3393	13.0%
7	1156	4.4%
8	993	3.8%
1	989	3.8%
6	975	3.7%
2	889	3.4%
0	860	3.3%
Other values (2)	897	3.4%

stadium_neutral
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

False	9676
True	49

Common Values
Chart

Value	Count	Frequency (%)
False	9676	99.5%
True	49	0.5%

dt_for_home
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	36
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.60972704
Minimum	0
Maximum	5448.926695
Zeros	9676
Zeros (%)	99.5%
Memory size	76.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5448.926695
Range	5448.926695
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	207.586132
Coefficient of variation (CV)	17.88036284
Kurtosis	476.7534646
Mean	11.60972704
Median Absolute Deviation (MAD)	0
Skewness	21.07824614
Sum	112904.5955
Variance	43092.00219
Monotocity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
0	9676	99.5%
58.1391836	5	0.1%
4263.231981	5	0.1%
1887.071311	2	< 0.1%
5358.710787	2	< 0.1%
1588.658994	2	< 0.1%
5446.312271	2	< 0.1%
4428.527773	2	< 0.1%
5448.926695	2	< 0.1%
1230.003353	1	< 0.1%
Other values (26)	26	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9676	99.5%
8.744298219	1	< 0.1%
27.67657288	1	< 0.1%
58.1391836	5	0.1%
501.901731	1	< 0.1%

Value	Count	Frequency (%)
5448.926695	2	< 0.1%
5446.312271	2	< 0.1%
5358.710787	2	< 0.1%
4441.205782	1	< 0.1%
4428.527773	2	< 0.1%

dt_for_away
Real number (ℝ_≥0)

Distinct	1534
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1002.414841
Minimum	1
Maximum	5277.157425
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	1
5-th percentile	182.5727665
Q1	462.1027044
median	872.6534573
Q3	1371.338114
95-th percentile	2301.123231
Maximum	5277.157425
Range	5276.157425
Interquartile range (IQR)	909.2354094

Descriptive statistics

Standard deviation	664.5236289
Coefficient of variation (CV)	0.6629227758
Kurtosis	0.312291373
Mean	1002.414841
Median Absolute Deviation (MAD)	443.2145362
Skewness	0.8356479375
Sum	9748484.329
Variance	441591.6534
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
171.2776779	49	0.5%
82.64345085	49	0.5%
286.1594702	47	0.5%
1371.338114	46	0.5%
170.3052887	45	0.5%
1094.539159	45	0.5%
258.1931562	44	0.5%
284.9683231	43	0.4%
1234.388611	43	0.4%
1174.34971	43	0.4%
Other values (1524)	9271	95.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	22	0.2%
26.68685437	2	< 0.1%
32.2548544	1	< 0.1%
82.64345085	49	0.5%
82.87903517	22	0.2%

Value	Count	Frequency (%)
5277.157425	1	< 0.1%
4850.994014	1	< 0.1%
4795.70311	1	< 0.1%
4628.653215	1	< 0.1%
4187.081133	1	< 0.1%

compass_away
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	76.1 KiB

NE	2967
NW	2662
SW	2209
SE	1887

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	19450
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SE
2nd row	NE
3rd row	SE
4th row	NW
5th row	NW

Value	Count	Frequency (%)
NE	2967	30.5%
NW	2662	27.4%
SW	2209	22.7%
SE	1887	19.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
ne	2967	30.5%
nw	2662	27.4%
sw	2209	22.7%
se	1887	19.4%

Most occurring characters

Value	Count	Frequency (%)
N	5629	28.9%
W	4871	25.0%
E	4854	25.0%
S	4096	21.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	19450	100.0%

Most frequent character per category

Value	Count	Frequency (%)
N	5629	28.9%
W	4871	25.0%
E	4854	25.0%
S	4096	21.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19450	100.0%

Most frequent character per script

Value	Count	Frequency (%)
N	5629	28.9%
W	4871	25.0%
E	4854	25.0%
S	4096	21.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19450	100.0%

Most frequent character per block

Value	Count	Frequency (%)
N	5629	28.9%
W	4871	25.0%
E	4854	25.0%
S	4096	21.1%

compass_home
Categorical

HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	8.2%
Missing	9676
Missing (%)	99.5%
Memory size	76.1 KiB

NE	23
SE	12
NW	8
SW	6

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	98
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NE
2nd row	SE
3rd row	NE
4th row	SE
5th row	NW

Value	Count	Frequency (%)
NE	23	0.2%
SE	12	0.1%
NW	8	0.1%
SW	6	0.1%
(Missing)	9676	99.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
ne	23	46.9%
se	12	24.5%
nw	8	16.3%
sw	6	12.2%

Most occurring characters

Value	Count	Frequency (%)
E	35	35.7%
N	31	31.6%
S	18	18.4%
W	14	14.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	98	100.0%

Most frequent character per category

Value	Count	Frequency (%)
E	35	35.7%
N	31	31.6%
S	18	18.4%
W	14	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	98	100.0%

Most frequent character per script

Value	Count	Frequency (%)
E	35	35.7%
N	31	31.6%
S	18	18.4%
W	14	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	98	100.0%

Most frequent character per block

Value	Count	Frequency (%)
E	35	35.7%
N	31	31.6%
S	18	18.4%
W	14	14.3%

elo1_pre
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9627
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1508.718489
Minimum	1197.301
Maximum	1839.663
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	1197.301
5-th percentile	1342.2866
Q1	1439.76274
median	1508.928
Q3	1577.621
95-th percentile	1670.48353
Maximum	1839.663
Range	642.362
Interquartile range (IQR)	137.8582602

Descriptive statistics

Standard deviation	99.0675304
Coefficient of variation (CV)	0.0656633634
Kurtosis	-0.2879641969
Mean	1508.718489
Median Absolute Deviation (MAD)	68.854
Skewness	-0.01664253106
Sum	14672287.3
Variance	9814.37558
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	3	< 0.1%
1524.291	2	< 0.1%
1485.903	2	< 0.1%
1600.701	2	< 0.1%
1584.024	2	< 0.1%
1495.303	2	< 0.1%
1617.383	2	< 0.1%
1456.739	2	< 0.1%
1425.547	2	< 0.1%
1419.698	2	< 0.1%
Other values (9617)	9704	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1197.301	1	< 0.1%
1200.129	1	< 0.1%
1219.33761	1	< 0.1%
1227.490928	1	< 0.1%
1228.056	1	< 0.1%

Value	Count	Frequency (%)
1839.663	1	< 0.1%
1831.462	1	< 0.1%
1824.224	1	< 0.1%
1821.815	1	< 0.1%
1810.502	1	< 0.1%

elo2_pre
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9612
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1507.068132
Minimum	1201.561463
Maximum	1825.961
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	1201.561463
5-th percentile	1343.489676
Q1	1439.334
median	1508.481
Q3	1576.814
95-th percentile	1663.519
Maximum	1825.961
Range	624.399537
Interquartile range (IQR)	137.48

Descriptive statistics

Standard deviation	97.18539006
Coefficient of variation (CV)	0.06448639449
Kurtosis	-0.356238729
Mean	1507.068132
Median Absolute Deviation (MAD)	68.688
Skewness	-0.07509450543
Sum	14656237.58
Variance	9445.00004
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1552.369	3	< 0.1%
1488.023	3	< 0.1%
1510.359	2	< 0.1%
1503.517	2	< 0.1%
1411.317	2	< 0.1%
1513.732	2	< 0.1%
1512.707	2	< 0.1%
1484.422	2	< 0.1%
1561.495	2	< 0.1%
1441.302	2	< 0.1%
Other values (9602)	9703	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1201.561463	1	< 0.1%
1210.773886	1	< 0.1%
1212.018	1	< 0.1%
1214.926	1	< 0.1%
1226.028	1	< 0.1%

Value	Count	Frequency (%)
1825.961	1	< 0.1%
1809.439	1	< 0.1%
1806.346	1	< 0.1%
1785.392	1	< 0.1%
1783.635	1	< 0.1%

elo_prob1
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9674
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5836280748
Minimum	0.0709532918
Maximum	0.9645780571
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	0.0709532918
5-th percentile	0.28779041
Q1	0.4666119068
median	0.594092781
Q3	0.7102463049
95-th percentile	0.8402533518
Maximum	0.9645780571
Range	0.8936247653
Interquartile range (IQR)	0.2436343981

Descriptive statistics

Standard deviation	0.167347844
Coefficient of variation (CV)	0.2867371382
Kurtosis	-0.5588378845
Mean	0.5836280748
Median Absolute Deviation (MAD)	0.121384362
Skewness	-0.2727265523
Sum	5675.783027
Variance	0.02800530088
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5355164624	2	< 0.1%
0.5855936739	2	< 0.1%
0.5316412315	2	< 0.1%
0.5851759268	2	< 0.1%
0.4393974708	2	< 0.1%
0.6258286985	2	< 0.1%
0.4402058761	2	< 0.1%
0.3245722568	2	< 0.1%
0.543909147	2	< 0.1%
0.5984509733	2	< 0.1%
Other values (9664)	9705	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0709532918	1	< 0.1%
0.1063242818	1	< 0.1%
0.1075087842	1	< 0.1%
0.1114412895	1	< 0.1%
0.1140957076	1	< 0.1%

Value	Count	Frequency (%)
0.9645780571	1	< 0.1%
0.9565612056	1	< 0.1%
0.9542541645	1	< 0.1%
0.9539438646	1	< 0.1%
0.9472871329	1	< 0.1%

elo_prob2
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9674
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4163719252
Minimum	0.03542194285
Maximum	0.9290467082
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	0.03542194285
5-th percentile	0.1597466482
Q1	0.2897536951
median	0.405907219
Q3	0.5333880932
95-th percentile	0.71220959
Maximum	0.9290467082
Range	0.8936247653
Interquartile range (IQR)	0.2436343981

Descriptive statistics

Standard deviation	0.167347844
Coefficient of variation (CV)	0.4019191348
Kurtosis	-0.5588378845
Mean	0.4163719252
Median Absolute Deviation (MAD)	0.121384362
Skewness	0.2727265523
Sum	4049.216973
Variance	0.02800530088
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6754277432	2	< 0.1%
0.4354778029	2	< 0.1%
0.54261507	2	< 0.1%
0.5715054084	2	< 0.1%
0.4694410967	2	< 0.1%
0.1425856297	2	< 0.1%
0.4683587685	2	< 0.1%
0.3617206455	2	< 0.1%
0.4644835376	2	< 0.1%
0.5311638963	2	< 0.1%
Other values (9664)	9705	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03542194285	1	< 0.1%
0.04343879442	1	< 0.1%
0.0457458355	1	< 0.1%
0.04605613537	1	< 0.1%
0.05271286707	1	< 0.1%

Value	Count	Frequency (%)
0.9290467082	1	< 0.1%
0.8936757182	1	< 0.1%
0.8924912158	1	< 0.1%
0.8885587105	1	< 0.1%
0.8859042924	1	< 0.1%

qbelo1_pre
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	9725
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1507.91921
Minimum	1198.229025
Maximum	1806.39016
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	1198.229025
5-th percentile	1347.139155
Q1	1441.815237
median	1509.836322
Q3	1573.636654
95-th percentile	1664.540825
Maximum	1806.39016
Range	608.1611351
Interquartile range (IQR)	131.8214173

Descriptive statistics

Standard deviation	95.54391819
Coefficient of variation (CV)	0.06336143047
Kurtosis	-0.2821861756
Mean	1507.91921
Median Absolute Deviation (MAD)	65.92825766
Skewness	-0.04901712861
Sum	14664514.32
Variance	9128.640303
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1494.924121	1	< 0.1%
1475.52048	1	< 0.1%
1393.538949	1	< 0.1%
1453.75684	1	< 0.1%
1552.161972	1	< 0.1%
1426.568652	1	< 0.1%
1457.057486	1	< 0.1%
1375.924841	1	< 0.1%
1456.738447	1	< 0.1%
1484.692771	1	< 0.1%
Other values (9715)	9715	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1198.229025	1	< 0.1%
1200.584923	1	< 0.1%
1226.746878	1	< 0.1%
1228.260981	1	< 0.1%
1229.675102	1	< 0.1%

Value	Count	Frequency (%)
1806.39016	1	< 0.1%
1800.256592	1	< 0.1%
1793.913721	1	< 0.1%
1792.062223	1	< 0.1%
1789.874163	1	< 0.1%

qbelo2_pre
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	9725
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1506.738767
Minimum	1206.174113
Maximum	1798.835806
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	1206.174113
5-th percentile	1347.798055
Q1	1441.904273
median	1509.452957
Q3	1573.941991
95-th percentile	1657.167627
Maximum	1798.835806
Range	592.6616936
Interquartile range (IQR)	132.0377187

Descriptive statistics

Standard deviation	93.71171232
Coefficient of variation (CV)	0.06219506286
Kurtosis	-0.3300392236
Mean	1506.738767
Median Absolute Deviation (MAD)	65.97244765
Skewness	-0.1080958958
Sum	14653034.51
Variance	8781.885026
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1610.345555	1	< 0.1%
1655.595854	1	< 0.1%
1372.356912	1	< 0.1%
1458.149751	1	< 0.1%
1496.603379	1	< 0.1%
1532.43637	1	< 0.1%
1492.225156	1	< 0.1%
1374.31293	1	< 0.1%
1541.737908	1	< 0.1%
1532.443456	1	< 0.1%
Other values (9715)	9715	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1206.174113	1	< 0.1%
1210.904201	1	< 0.1%
1213.203583	1	< 0.1%
1220.838048	1	< 0.1%
1223.696643	1	< 0.1%

Value	Count	Frequency (%)
1798.835806	1	< 0.1%
1795.514049	1	< 0.1%
1783.219349	1	< 0.1%
1783.044649	1	< 0.1%
1779.011293	1	< 0.1%

qb1_value_pre
Real number (ℝ)

Distinct	9671
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	104.5766828
Minimum	-53.77891723
Maximum	317.472758
Zeros	33
Zeros (%)	0.3%
Memory size	76.1 KiB

Quantile statistics

Minimum	-53.77891723
5-th percentile	19.93142791
Q1	60.39579427
median	98.42855351
Q3	142.2045079
95-th percentile	213.3488834
Maximum	317.472758
Range	371.2516753
Interquartile range (IQR)	81.80871365

Descriptive statistics

Standard deviation	58.95798196
Coefficient of variation (CV)	0.5637775114
Kurtosis	-0.01468244333
Mean	104.5766828
Median Absolute Deviation (MAD)	40.5139525
Skewness	0.5042780088
Sum	1017008.24
Variance	3476.043637
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33	0.3%
112.90158	7	0.1%
103.37976	4	< 0.1%
42.077376	2	< 0.1%
66.19932	2	< 0.1%
32.64624	2	< 0.1%
16.32312	2	< 0.1%
28.11204	2	< 0.1%
52.1433	2	< 0.1%
112.44816	2	< 0.1%
Other values (9661)	9667	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-53.77891723	1	< 0.1%
-44.9854437	1	< 0.1%
-39.03696052	1	< 0.1%
-38.10632704	1	< 0.1%
-35.86706908	1	< 0.1%

Value	Count	Frequency (%)
317.472758	1	< 0.1%
313.8283835	1	< 0.1%
308.762381	1	< 0.1%
306.8441324	1	< 0.1%
305.2544619	1	< 0.1%

qb2_value_pre
Real number (ℝ)

Distinct	9690
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	104.4098118
Minimum	-45.31072334
Maximum	327.7165449
Zeros	26
Zeros (%)	0.3%
Memory size	76.1 KiB

Quantile statistics

Minimum	-45.31072334
5-th percentile	20.31476558
Q1	61.02975275
median	97.59695147
Q3	141.4013777
95-th percentile	212.9138725
Maximum	327.7165449
Range	373.0272682
Interquartile range (IQR)	80.37162497

Descriptive statistics

Standard deviation	58.4171454
Coefficient of variation (CV)	0.5594986179
Kurtosis	-0.02450860585
Mean	104.4098118
Median Absolute Deviation (MAD)	39.79824715
Skewness	0.504049428
Sum	1015385.42
Variance	3412.562877
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26	0.3%
112.90158	5	0.1%
23.12442	2	< 0.1%
108.8208	2	< 0.1%
74.8143	2	< 0.1%
61.28942914	2	< 0.1%
111.99474	2	< 0.1%
68.013	2	< 0.1%
99.26091765	1	< 0.1%
86.22406988	1	< 0.1%
Other values (9680)	9680	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-45.31072334	1	< 0.1%
-36.56794713	1	< 0.1%
-34.94990164	1	< 0.1%
-33.93220331	1	< 0.1%
-29.9072105	1	< 0.1%

Value	Count	Frequency (%)
327.7165449	1	< 0.1%
310.130678	1	< 0.1%
307.0342645	1	< 0.1%
300.7618581	1	< 0.1%
300.2340833	1	< 0.1%

qbelo_prob1
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	9725
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5759398122
Minimum	0.05981049406
Maximum	0.9671966037
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	0.05981049406
5-th percentile	0.2759039736
Q1	0.4540434789
median	0.5874577138
Q3	0.7083993485
95-th percentile	0.8397586078
Maximum	0.9671966037
Range	0.9073861096
Interquartile range (IQR)	0.2543558696

Descriptive statistics

Standard deviation	0.1721991186
Coefficient of variation (CV)	0.2989880452
Kurtosis	-0.5921599876
Mean	0.5759398122
Median Absolute Deviation (MAD)	0.1273096889
Skewness	-0.2569352478
Sum	5601.014674
Variance	0.02965253645
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6153388441	1	< 0.1%
0.511120899	1	< 0.1%
0.7377304275	1	< 0.1%
0.5943983535	1	< 0.1%
0.6697278297	1	< 0.1%
0.5111690156	1	< 0.1%
0.8636031118	1	< 0.1%
0.6050896546	1	< 0.1%
0.7594710452	1	< 0.1%
0.85167685	1	< 0.1%
Other values (9715)	9715	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.05981049406	1	< 0.1%
0.07022884764	1	< 0.1%
0.08621392691	1	< 0.1%
0.1005701713	1	< 0.1%
0.1007093328	1	< 0.1%

Value	Count	Frequency (%)
0.9671966037	1	< 0.1%
0.9659098421	1	< 0.1%
0.9565738744	1	< 0.1%
0.9522683646	1	< 0.1%
0.9483917689	1	< 0.1%

qbelo_prob2
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	9725
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4240601878
Minimum	0.03280339633
Maximum	0.9401895059
Zeros	0
Zeros (%)	0.0%
Memory size	76.1 KiB

Quantile statistics

Minimum	0.03280339633
5-th percentile	0.1602413922
Q1	0.2916006515
median	0.4125422862
Q3	0.5459565211
95-th percentile	0.7240960264
Maximum	0.9401895059
Range	0.9073861096
Interquartile range (IQR)	0.2543558696

Descriptive statistics

Standard deviation	0.1721991186
Coefficient of variation (CV)	0.4060723538
Kurtosis	-0.5921599876
Mean	0.4240601878
Median Absolute Deviation (MAD)	0.1273096889
Skewness	0.2569352478
Sum	4123.985326
Variance	0.02965253645
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7668245439	1	< 0.1%
0.4124150663	1	< 0.1%
0.309169177	1	< 0.1%
0.2275465852	1	< 0.1%
0.6690800474	1	< 0.1%
0.43937645	1	< 0.1%
0.3665085786	1	< 0.1%
0.3781879659	1	< 0.1%
0.4030777744	1	< 0.1%
0.272325196	1	< 0.1%
Other values (9715)	9715	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03280339633	1	< 0.1%
0.03409015793	1	< 0.1%
0.04342612561	1	< 0.1%
0.0477316354	1	< 0.1%
0.05160823111	1	< 0.1%

Value	Count	Frequency (%)
0.9401895059	1	< 0.1%
0.9297711524	1	< 0.1%
0.9137860731	1	< 0.1%
0.8994298287	1	< 0.1%
0.8992906672	1	< 0.1%

home_fav
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	76.1 KiB

1	6506
0	3219

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9725
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	6506	66.9%
0	3219	33.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	6506	66.9%
0	3219	33.1%

Most occurring characters

Value	Count	Frequency (%)
1	6506	66.9%
0	3219	33.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9725	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	6506	66.9%
0	3219	33.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	9725	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	6506	66.9%
0	3219	33.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9725	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	6506	66.9%
0	3219	33.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	result	spread_favorite	over_under_line	stadium_neutral	dt_for_away	compass_away	compass_home	elo1_pre	elo2_pre	elo_prob1	elo_prob2	qbelo1_pre	qbelo2_pre	qb1_value_pre	qb2_value_pre	qbelo_prob1	qbelo_prob2	home_fav
0	2298	1	-3.0	30	False	988.905373	SE	NaN	1385.204	1487.039	0.447188	0.552812	1382.928035	1501.886317	35.516718	55.159981	0.427168	0.572832	1
1	2299	0	-5.0	39	False	1174.349710	NE	NaN	1422.820	1573.513	0.379119	0.620881	1423.239353	1559.950522	58.063485	96.122345	0.375353	0.624647	0
2	2300	1	-3.0	31	False	184.036793	SE	NaN	1485.806	1462.502	0.624412	0.375588	1483.909490	1464.019768	42.756791	41.494668	0.608396	0.391604	1
3	2301	1	-3.0	31.5	False	1095.723761	NW	NaN	1579.121	1491.380	0.706666	0.293334	1580.348626	1487.024327	21.700888	90.929408	0.675602	0.324398	1
4	2302	1	-1.0	37	False	958.341925	NW	NaN	1408.082	1420.160	0.575577	0.424423	1411.647742	1424.210902	49.196730	121.414496	0.528007	0.471993	1
5	2303	0	-4.0	36.5	False	369.669204	SE	NaN	1571.837	1543.108	0.631707	0.368293	1570.530350	1554.746347	79.889828	39.539531	0.617516	0.382484	1
6	2304	1	-7.0	32	False	1584.373778	NE	NaN	1501.070	1376.895	0.748189	0.251811	1501.392697	1385.556901	16.152145	14.950634	0.707520	0.292480	1
7	2305	0	-5.0	32	False	424.760553	SW	NaN	1454.541	1472.748	0.566936	0.433064	1447.159545	1464.242458	135.575094	57.511763	0.563144	0.436856	1
8	2306	0	-2.0	41	False	400.081904	SE	NaN	1486.703	1483.734	0.596586	0.403414	1491.273443	1479.160062	32.187388	118.072233	0.578964	0.421036	1
9	2307	1	-7.0	31.5	False	82.958831	SW	NaN	1516.285	1435.862	0.697859	0.302141	1515.401198	1430.892805	68.939029	47.936408	0.686289	0.313711	1

Last rows

	df_index	result	spread_favorite	over_under_line	stadium_neutral	dt_for_away	compass_away	compass_home	elo1_pre	elo2_pre	elo_prob1	elo_prob2	qbelo1_pre	qbelo2_pre	qb1_value_pre	qb2_value_pre	qbelo_prob1	qbelo_prob2	home_fav
9715	12013	1	-11.0	48	False	833.524038	SW	NaN	1695.683599	1500.118465	0.817565	0.182435	1730.534638	1497.160456	222.286925	164.839331	0.849820	0.150180	1
9716	12014	0	-5.5	47.5	False	114.228939	SE	NaN	1572.161442	1516.981769	0.666369	0.333631	1578.445722	1536.927531	204.930263	164.489312	0.619443	0.380557	1
9717	12015	0	-3.5	53.5	False	596.492606	SW	NaN	1599.076599	1654.215004	0.514188	0.485812	1571.696393	1651.052726	216.955557	249.565673	0.425714	0.574286	0
9718	12016	1	-2.5	49.5	False	265.725548	NW	NaN	1700.538009	1675.695777	0.626487	0.373513	1688.252986	1668.348824	289.086698	243.185225	0.652886	0.347114	1
9719	12017	1	-7.0	45	False	1758.300526	NE	NaN	1700.226062	1620.498535	0.697014	0.302986	1674.786093	1633.700632	266.649955	161.674529	0.710875	0.289125	1
9720	12018	1	-8.0	56	False	696.123935	SW	NaN	1712.652090	1552.012725	0.785647	0.214353	1711.217029	1568.944343	273.850726	182.717766	0.789927	0.210073	1
9721	12019	0	-2.5	53	False	481.270463	NW	NaN	1704.051294	1645.074008	0.671212	0.328788	1737.311296	1624.424406	226.770860	221.777906	0.705859	0.294141	1
9722	12020	0	-3.0	53	False	1198.450281	NW	NaN	1715.623187	1679.186255	0.641968	0.358032	1689.406792	1660.789489	276.653962	221.747091	0.629191	0.370809	1
9723	12021	1	-3.0	55	False	856.619992	SW	NaN	1719.618921	1719.974149	0.591972	0.408028	1718.032247	1706.159766	271.760879	273.290046	0.535637	0.464363	1
9724	12022	1	-3.0	56	False	1033.075041	SE	NaN	1703.303296	1741.087279	0.539087	0.460913	1684.319058	1742.902172	211.680227	282.261326	0.466206	0.533794	0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows